// 其它收/支,预收/付账款 明细票据
const {DataTypes, db } = require("../db");
db.define('invoiceOther', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,defaultValue:0,comment:''}, 
iid:{type: DataTypes.INTEGER,comment:'自身关联单据ID'}, 
accId:{type: DataTypes.INTEGER,allowNull:false,comment:'账户ID'}, 
subjectId:{type: DataTypes.INTEGER,comment:'科目ID'}, 
amount:{type: DataTypes.DECIMAL(20, 2),allowNull:false,comment:'金额'}, 
remark:{type: DataTypes.STRING(255),comment:'备注'}, 
billNo:{type: DataTypes.STRING(100),comment:'票号'}, 
buId:{type: DataTypes.INTEGER,comment:'往来单位ID'}, 
buName:{type: DataTypes.STRING(255),comment:'往来单位'}, 
subjectName:{type: DataTypes.STRING(255),comment:'科目名称'}, 
accName:{type: DataTypes.STRING(50),comment:'账户名称'}, 
billState:{type: DataTypes.STRING(50),comment:''}, 
transType:{type: DataTypes.INTEGER,comment:''}, 
employeeId:{type: DataTypes.INTEGER,comment:'员工ID'}, 
employeeName:{type: DataTypes.STRING(255),comment:'员工'}, 

}, {
    tableName: 'invoice_other',
    timestamps: false,
    comment: '其它收/支,预收/付账款 明细票据',
    
});